﻿/*
LICENCE___________________________________________________________________
    Copyright (C) 2012 Reverdy Sylvain

    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License along
    with this program; if not, write to the Free Software Foundation, Inc.,
    51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
FIN LICENCE______________________________________________________________
*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace Merise_designer.Donnees
{
    class CL_Lignes
    {
        private CL_CAD cad = new CL_CAD();
        
        public void add(Objets.CL_Line ligne)
        {
            string req = @"INSERT INTO LIGNES (ID_LIGNE, ID_ENTITE, ID_ASSO, CARDINALITE) VALUES('" + ligne.Id + "','" + ligne.IdEntite + "','" + ligne.IdAssociation + "','" + ligne.Cardinalite + "') ";
            cad.ActionsRows(req, true);
        }

        public String getAdd(Objets.CL_Line ligne)
        {
           return @"INSERT INTO LIGNES (ID_LIGNE, ID_ENTITE, ID_ASSO, CARDINALITE) VALUES('" + ligne.Id + "','" + ligne.IdEntite + "','" + ligne.IdAssociation + "','" + ligne.Cardinalite + "');";
        }


        public void update(Objets.CL_Line line)
        {
            string req = @"UPDATE LIGNES SET ID_ENTITE='" + line.IdEntite + "',  ID_ASSO='" + line.IdAssociation + "',  CARDINALITE='" + line.Cardinalite + "' WHERE ID_LIGNE='" + line.Id + "'";
            cad.ActionsRows(req, true);
        }

        public void deleteAll()
        {
            string req = @"DELETE FROM LIGNES";
            cad.ActionsRows(req, true);
        }
        public String getDeleteAll()
        {
            return @"DELETE FROM LIGNES;";
        }

        public void delete(string id)
        {
            string req = @"DELETE FROM LIGNES WHERE ID_LIGNE='" + id + "'";
            cad.ActionsRows(req, true);
        }

        public DataSet selectAll(string monJeu)
        {
            string req = @"SELECT ID_LIGNE, ID_ENTITE, ID_ASSO, CARDINALITE FROM LIGNES";
            return cad.GetRows(req, monJeu);
        }

        public DataSet select(string idLigne, string monJeu)
        {
            string req = @"SELECT ID_LIGNE, ID_ENTITE, ID_ASSO, CARDINALITE FROM LIGNES WHERE ID_LIGNE='" + idLigne + "'";
            return cad.GetRows(req, monJeu);
        }
    }
}
